UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7uZVI57a2NJdgfnm9M2YOmV/5Z5Qg0rv731BbY7+z0M='
WHERE
key_id = '8e3c86915b5ccc899c819787691b4b977ac9eac20b7c23644b26d1409c562eb9'
AND (
token = '7uZVI57a2NJdgfnm9M2YOmV/5Z5Qg0rv731BbY7+z0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)