UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y7ZnsvmheicESbc6BTiMuJBnpYNVycyyu3fAYPX8WOY='
WHERE
key_id = 'c8e4b53653a0be725b77c5f3ce6d49c64c27e75803b11456ea4dcc27cc210df9'
AND (
token = 'Y7ZnsvmheicESbc6BTiMuJBnpYNVycyyu3fAYPX8WOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)