UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TPC1bdtRrHQxAnL8lQM5W9bYLb3mfJIhWyH/pi1mDBk='
WHERE
key_id = '20ca3671f237ad35e1f2131a9e477bb660136af7670084496999dd881eaa51db'
AND (
token = 'TPC1bdtRrHQxAnL8lQM5W9bYLb3mfJIhWyH/pi1mDBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)