UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KhWpE8rvtFfXdc1BpDxCePBY0VMxPilSDfAsztC2gc4='
WHERE
key_id = '208dbf034dc8ae94fa954868435dfab9567ff2d25cb04bf46f0760531cb3d97c'
AND (
token = 'KhWpE8rvtFfXdc1BpDxCePBY0VMxPilSDfAsztC2gc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)