UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgUKNUZrWjcEkpzm29QAESAxw5akOv4T1di4Cq6vGnU='
WHERE
key_id = '30736c3d762fe77ec3e5302cd5ddfc7a1d474e6799f432d92757142f0e6eb844'
AND (
token = 'BgUKNUZrWjcEkpzm29QAESAxw5akOv4T1di4Cq6vGnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)