UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vLqYREMRpD7khjUPN5oVNtAeWuU9XfHRQh/Sy2s/9zc='
WHERE
key_id = '42e80f526ba3aa59cbaf78a6c6a7b86ba17f3adcee2fba9c6dd03d6689280cf8'
AND (
token = 'vLqYREMRpD7khjUPN5oVNtAeWuU9XfHRQh/Sy2s/9zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)