UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kOhK2q3ocbwXTTmMrbwuEk87vplJnDeCSPi41K8kCw4='
WHERE
key_id = '90dd1e5775481008556296ebbb97564fea27b65eea3237f420ce3c3dc9df88f6'
AND (
token = 'kOhK2q3ocbwXTTmMrbwuEk87vplJnDeCSPi41K8kCw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)