UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8eQ0B74wvFLyYqaloMGeEyPXBjTcPKbIjMV86ffsOQ='
WHERE
key_id = 'c42904e09d80a3647980f267713b0937bf58ff3546431c341c55278bd003db93'
AND (
token = 'B8eQ0B74wvFLyYqaloMGeEyPXBjTcPKbIjMV86ffsOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)