UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abXX27XjpAAWfFUzTr1QnpjsGQzZ2a77iPnSAldsmoA='
WHERE
key_id = '9b442635ba62f55e037b9fb9e556a87def86a3f12a74f6c27ce1752229733aac'
AND (
token = 'abXX27XjpAAWfFUzTr1QnpjsGQzZ2a77iPnSAldsmoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)