UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lj4ucK/kz0GGnpnz4LKFruAmmpFweIkGNC37/O/MybA='
WHERE
key_id = 'aac0109449372b081a7001bcb33447cf52d2b44a238efc002b76ef54cf5afbc6'
AND (
token = 'lj4ucK/kz0GGnpnz4LKFruAmmpFweIkGNC37/O/MybA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)