UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDQPKKN8ux2wZq0o95rJW7YOONkWYPSWEkWbapv79XQ='
WHERE
key_id = '8c6de570339720722ccf46ff8558f2102167b9ba17811ca3bb76b4ee4bac27fb'
AND (
token = 'sDQPKKN8ux2wZq0o95rJW7YOONkWYPSWEkWbapv79XQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)