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