UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiQ+aZLv/jRyVwLaDqhyH1bTFmnJiZyPcwizDRCgjVA='
WHERE
key_id = '6c167199c1080d2843c44aea0b52be129256ea01a5d8732c823d63dbd5edad2b'
AND (
token = 'hiQ+aZLv/jRyVwLaDqhyH1bTFmnJiZyPcwizDRCgjVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)