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