UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JQv6L+jbYMwCB1/b096OVUcVTnwSWiKf0nzcs5sYmyM='
WHERE
key_id = 'f6ea9bea287155ad6ab130a1d2efe0e6349f2edf7d5320ffda7a431e43cd92e4'
AND (
token = 'JQv6L+jbYMwCB1/b096OVUcVTnwSWiKf0nzcs5sYmyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)