UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXgN1v9yaAeRUg896BU2sHIin7cV2taSBZfjdKk+wvY='
WHERE
key_id = '01cb49ff1deebe9f0e42e4be8134bceeb940b2d37506d1093fb3b2ca90c1586e'
AND (
token = 'yXgN1v9yaAeRUg896BU2sHIin7cV2taSBZfjdKk+wvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)