UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gUUNOfiwnNC6EkThcEZ0I+396/xj1Uo8LbHruCq+UHs='
WHERE
key_id = 'e71605efb9709e19fb187cf5e8f0d855671c9066b32886e99656a171c1e3d7fa'
AND (
token = 'gUUNOfiwnNC6EkThcEZ0I+396/xj1Uo8LbHruCq+UHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)