UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N0HBXW2tLvMRqB4YKKsQHFYG+XAY4xo1QwaO62vNHTE='
WHERE
key_id = '1a23c2f17860444c189aad91a7a4b23b197fddb788feb10e1824425b5ade022f'
AND (
token = 'N0HBXW2tLvMRqB4YKKsQHFYG+XAY4xo1QwaO62vNHTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)