UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0giU+fCYJ+oGgluSYckV1cnjpr5RUci4TU7WkTN/FE4='
WHERE
key_id = 'b52c1f0d02d29a88ec8279f289f8b7883b0711ee2a5f88580844c87b9d412221'
AND (
token = '0giU+fCYJ+oGgluSYckV1cnjpr5RUci4TU7WkTN/FE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)