UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cg2p1e9oRpz3f4PKt0lUAuIfxjNYg9wSPk99Yivb9yw='
WHERE
key_id = '4d2ea74eecf42cb5d9f71dadb4ea5a8ac85b84e843eb9a77b201cf77a54e35f0'
AND (
token = 'Cg2p1e9oRpz3f4PKt0lUAuIfxjNYg9wSPk99Yivb9yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)