UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vREd2Jo2Sy4DfGiF18M99ZRNInoQTLfC6iWI55SVy8w='
WHERE
key_id = '8a5ca6810e606622e0bc0cbbb8616d1cdef955e340c3249133a9a28236d17e3c'
AND (
token = 'vREd2Jo2Sy4DfGiF18M99ZRNInoQTLfC6iWI55SVy8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)