UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GyADY5tLQKK6DS5DyC8cNJEAFq3y3aG/dIkFYAyzUo='
WHERE
key_id = '6457c28508cac2fd47a16aa6f45b3355837e0409eb7b17b827288f949e0e134a'
AND (
token = '0GyADY5tLQKK6DS5DyC8cNJEAFq3y3aG/dIkFYAyzUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)