UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S+nqr516C0Kc/ZgCFLbWziGconA174051VncWY6v+/U='
WHERE
key_id = '40eeeb6b3e5d7ddf298b64dc1db7eee88c4b6c25a4f0ba532c3ddfa24db4fab7'
AND (
token = 'S+nqr516C0Kc/ZgCFLbWziGconA174051VncWY6v+/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)