UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6R2d9BAGuuGKha3iJxv+iv+dXfvduuuI6NA2qteEbA='
WHERE
key_id = '2043dff04bc6dec4991f974c5585822883d479d9177f66405abee700acf302fb'
AND (
token = 'P6R2d9BAGuuGKha3iJxv+iv+dXfvduuuI6NA2qteEbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)