UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tYVaH7qNI1HLOfIq14s6O/XxvH+nmgN/wctAGc9OY78='
WHERE
key_id = 'fa34f8850a591de481ed842ccb10616b165fbe635e56bf83ba49b2b055e667bd'
AND (
token = 'tYVaH7qNI1HLOfIq14s6O/XxvH+nmgN/wctAGc9OY78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)