UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'do4aZq2mqNS8QQO4ZpvGdQlA5d5B5aerAfulCgFJ9Kw='
WHERE
key_id = 'd42e15ef03cdb357c5312c684a6354b4efcf5d45221b19eddf5665b3c0f20c1f'
AND (
token = 'do4aZq2mqNS8QQO4ZpvGdQlA5d5B5aerAfulCgFJ9Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)