UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G3h6X/wwycRNLmeBCsj0GdAXJV+HqHl4aojuOAC5Hn4='
WHERE
key_id = '247fb4acbf4b999ecbc8ed6a50e7f5a9ec076042cc472e5286d2f8bf349ca1cd'
AND (
token = 'G3h6X/wwycRNLmeBCsj0GdAXJV+HqHl4aojuOAC5Hn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)