UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n59uOptSYSk1fdmepO6g/cEW6J8w6k1L5i8rTvtkLB8='
WHERE
key_id = 'd8fee1780b104cb6814a03e530899e685932f8e512879503e366e8f0ea4390ce'
AND (
token = 'n59uOptSYSk1fdmepO6g/cEW6J8w6k1L5i8rTvtkLB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)