UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UXBeD4hYSmGXccdHe90JlmAcTo9fS+ptcqaj6o4raf0='
WHERE
key_id = 'dba840d27c2832800a277c4f2186bb1b64b388d133e01a43b8518ac87677cfa2'
AND (
token = 'UXBeD4hYSmGXccdHe90JlmAcTo9fS+ptcqaj6o4raf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)