UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd19Z7xqm18cCx5fEnTmx3jD3zLOjp7tG3GMPhvypg5E='
WHERE
key_id = '2ffad233702811a6685b32039a51c0978e1e38c6dcbaf25daf8d02752a4fa005'
AND (
token = 'd19Z7xqm18cCx5fEnTmx3jD3zLOjp7tG3GMPhvypg5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)