UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yoS01jm6ojH4r6Ye856TF/w4xVi4qBvyLWIF+S3U94='
WHERE
key_id = '93e524d64093e41ba59a515aea46b0d0eb61b6c1725e83642d3c0b5e1ccf1bc6'
AND (
token = '8yoS01jm6ojH4r6Ye856TF/w4xVi4qBvyLWIF+S3U94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)