UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2gONejjzuIOaBiJO1sIWaICHIvKZTPuEMfYNrHb3Rj8='
WHERE
key_id = '6ccaf2b4f96778702be540b1f7f38d4220c4a9336c03e8c3d3dc13c48d59ab62'
AND (
token = '2gONejjzuIOaBiJO1sIWaICHIvKZTPuEMfYNrHb3Rj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)